﻿
CREATE PROCEDURE dbo.smenu_Notify_Underwriter
	(
		@ApplID int
	)
AS
SET NOCOUNT ON


DECLARE @User varchar(50)

SET @User = dbo.GuessUnderwriter(@ApplID)

DECLARE @Cmd nvarchar(512),@JobName nvarchar(512)
SET @Cmd = dbo.sprintf1('EXEC s_MenuArriveMsg $0,''$1''',@ApplID,@User)
SET @JobName = dbo.sprintf0('Notify_Underwriter $0',@ApplID)
EXEC sched_Job @JobName,@Cmd

--EXEC sh_Debug_Put 'smenu_Notify_Underwriter<>Cmd:$0',@Cmd

